UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l81tZCeVslc7F9aui/Ugp5+ldxE4wPIEDuMrt4QASSA='
WHERE
key_id = '4326b7cbb378f22730785ceaa9baa051c8728ea8d8a6ecab15d1f02a4f988ba2'
AND (
token = 'l81tZCeVslc7F9aui/Ugp5+ldxE4wPIEDuMrt4QASSA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)