UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hzQCu4mAHDxfqJYBEPyPNIU+ZPw4mVeAvoFW0qFgCAk='
WHERE
key_id = 'f0c14aff3184f69132eef8b36698d97ff9889cdb77d351a38378f45d6c653ce9'
AND (
token = 'hzQCu4mAHDxfqJYBEPyPNIU+ZPw4mVeAvoFW0qFgCAk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)