UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zjLWWzaed6zxew0LXLxJdeuY5xgeOEbI7uMtriOPVrU='
WHERE
key_id = '68cc4e2a91d27518f454b67a4be7943c9c94ff17cf115aa99febf51408a3ee23'
AND (
token = 'zjLWWzaed6zxew0LXLxJdeuY5xgeOEbI7uMtriOPVrU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)