UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gFtNoRe1QJ8ZMP9buXvG8Mg267ueDkQQ27djUpn8ggg='
WHERE
key_id = 'bb84b3ab85ed4cdd8123825bd76997d48b0305e004bca4496b9ccb2451f053b5'
AND (
token = 'gFtNoRe1QJ8ZMP9buXvG8Mg267ueDkQQ27djUpn8ggg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)