UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6VCswBS489+AVuoVC4sMKkuUn156EqkGR942rZ4cd+I='
WHERE
key_id = '89782823570d7c59c50437db9ec55955fb7fbdfef7b788c07331e05f41f9467a'
AND (
token = '6VCswBS489+AVuoVC4sMKkuUn156EqkGR942rZ4cd+I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)