UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1XJd0VfS3kYgc2LZiomBLSnzKLBSCEzMauH/yR3Dz9k='
WHERE
key_id = '499b747387651333a64e10aff4c2152fcb313c993ea485e26544d84e2f1ea659'
AND (
token = '1XJd0VfS3kYgc2LZiomBLSnzKLBSCEzMauH/yR3Dz9k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)