UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JkvfxsYZC4ly4LkEYZVf/Dtks7sWr1j8Jt/0jJBnmnE='
WHERE
key_id = 'cdd0ab87b66cac60ef92644d5571791ad2306a419f13e9c98a1117925ea4cbdf'
AND (
token = 'JkvfxsYZC4ly4LkEYZVf/Dtks7sWr1j8Jt/0jJBnmnE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)