UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '59366XesBQYDZXhj3pDV8itxuZhsVmcnk6u1+v7vVh0='
WHERE
key_id = 'e42710d01f699ae8a14f4592261400c26d2a3ee22bd3ffe4a17486e8c7ef1bb0'
AND (
token = '59366XesBQYDZXhj3pDV8itxuZhsVmcnk6u1+v7vVh0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)