UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lV4ofSV/TKALMCEM4GmOj6wS/l6vMsVCZA/DmWvUKPE='
WHERE
key_id = '0ef7f678c48628ff00f242e960e89a72640d6c944861c3f5774e28175b7c5385'
AND (
token = 'lV4ofSV/TKALMCEM4GmOj6wS/l6vMsVCZA/DmWvUKPE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)