UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZQF+DH9Jf12n3yp6N1xTuQT/H+xCnd3d5e6HTWuWv00='
WHERE
key_id = '529065b8c50d122cfb1e55d6f03859ed05e8af69ddcd3d96d303a226174efb47'
AND (
token = 'ZQF+DH9Jf12n3yp6N1xTuQT/H+xCnd3d5e6HTWuWv00='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)