UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9q/OUUECD4PRGlbV74Xifv1uITLL4F0cZ3YrIpfH8Hg='
WHERE
key_id = '0189b2b0e1d39c4665f0770fa36dc41364eb59c283ea6be53b309a79615b1ff3'
AND (
token = '9q/OUUECD4PRGlbV74Xifv1uITLL4F0cZ3YrIpfH8Hg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)