UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TvL3MqdK12BxKnHcDnNCxs460TQx47Qi/EGElGR8bOc='
WHERE
key_id = '6f23b515c2525e9ace81ff61758b2b1ef4d962e604fd57f1b4b7eea3764985a3'
AND (
token = 'TvL3MqdK12BxKnHcDnNCxs460TQx47Qi/EGElGR8bOc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)