UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UcJiUre5GxJLUeBqvYHk3Eu3jojTdX9tr+QXAUUn6oo='
WHERE
key_id = '02bb3fa17f6b11efee5fb478a0b99ccc74def944f05986349f0cfdc491cce972'
AND (
token = 'UcJiUre5GxJLUeBqvYHk3Eu3jojTdX9tr+QXAUUn6oo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)