UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D6ANJeEGgQE0+eIY/2qY/KHpZ4kwEy61vOwKIlRKHMg='
WHERE
key_id = '187819edcd3c0a71b638488a123233607e99ff33a40e8da037b407d965aa095b'
AND (
token = 'D6ANJeEGgQE0+eIY/2qY/KHpZ4kwEy61vOwKIlRKHMg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)