UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZFGVl/7yYfAXr5HxRAYJCGZRUofUbyl6jEOiMvi7Yk4='
WHERE
key_id = '4d1e2a9b3107ee1a2cea0565d99f196cb422c32adadab7a2c1bf562be9e7bb71'
AND (
token = 'ZFGVl/7yYfAXr5HxRAYJCGZRUofUbyl6jEOiMvi7Yk4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)