UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qcH8iywfJjMJtfKdBn8Yi5D0l2SywRdVoZPB62EDMQA='
WHERE
key_id = '9e8cb1be6f1c235cc4dbdfd3adae74086e9969f9772ab20d4c81a2530a33f650'
AND (
token = 'qcH8iywfJjMJtfKdBn8Yi5D0l2SywRdVoZPB62EDMQA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)