UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'O/1cLxYSIlzEOoMpbzErkgqXHJYxB9UOAckSv6ip6ms='
WHERE
key_id = '2b34e56d27c09de90c4905370cc307ca9ab107c17003158e93a652cee958d962'
AND (
token = 'O/1cLxYSIlzEOoMpbzErkgqXHJYxB9UOAckSv6ip6ms='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)