UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cZ3/vHFhBjgv2+Uyk/zpH9nKIHT7nQ3FwKmX1HanZmA='
WHERE
key_id = 'c872f5cb178b82a10bebfeb269c5c645f0aae869aa450974a00b8c9af4fbf22e'
AND (
token = 'cZ3/vHFhBjgv2+Uyk/zpH9nKIHT7nQ3FwKmX1HanZmA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)