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