UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TDv8kMMwp/eafcKyU1TRlSe2iPidkzK9hsGP1Kcm/oo='
WHERE
key_id = '07c2a924ad9d5eb3f3a6d632bcca2b461c4f6ab53de5b7bbe73cb912d50e4df5'
AND (
token = 'TDv8kMMwp/eafcKyU1TRlSe2iPidkzK9hsGP1Kcm/oo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)