UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '271BCgefeLli3YNS2rzSN3huzBWy6alrWCypAjDqYhU='
WHERE
key_id = '11d41ffbbaffc769f3a36fd398f74e00eb14f00e19283b709301a6a61fa2b1cd'
AND (
token = '271BCgefeLli3YNS2rzSN3huzBWy6alrWCypAjDqYhU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)