UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gRhf6MnOlySxcLnV31kzeENnAaivFph+VNiWaNSP2R0='
WHERE
key_id = 'c3d4fffebf13c2203248c3681fa0c9b604b846e9631ef4e44e3be4301f9c8284'
AND (
token = 'gRhf6MnOlySxcLnV31kzeENnAaivFph+VNiWaNSP2R0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)