UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NfYKecg4rtEaQYscvKfcRa5i5RA1eAk1hiTJvKxTSqE='
WHERE
key_id = '674811a9c8e25452905f5f2f3e3866dfd82370ce5bb1a55619845f74a78bc03b'
AND (
token = 'NfYKecg4rtEaQYscvKfcRa5i5RA1eAk1hiTJvKxTSqE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)