UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TWfMXYMTS7DLsMExUQiS7p/71O8LUcyV9mcmZRbOuaA='
WHERE
key_id = 'd89b2d7d3fd517a25076bc2161fab718c9ab810d9d8260c81e2424348480f3d7'
AND (
token = 'TWfMXYMTS7DLsMExUQiS7p/71O8LUcyV9mcmZRbOuaA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)