UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SK2aunjXnYQMdFZz73KAMygd9tICaAdHNHNwZISGCbs='
WHERE
key_id = 'c22d3cbc136167a1ec141e25faa4b49a096d13a757199b1ee4a1bf292a8886f1'
AND (
token = 'SK2aunjXnYQMdFZz73KAMygd9tICaAdHNHNwZISGCbs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)