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