UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hYgQgjjfR59+VDXzNh0qFooxoFuN4naxpFcEpRLSrPU='
WHERE
key_id = '9277b98c86eb5ec31db9641ffe1eac9a2542221bd7c971813f9e40a90701de19'
AND (
token = 'hYgQgjjfR59+VDXzNh0qFooxoFuN4naxpFcEpRLSrPU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)