UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v0BSCuSP/T8uiCWaodvOfsGxPC4BjVHnGm6M0mAJn0Y='
WHERE
key_id = '41f0a6ec06a120173b5ea068fef2c267b72086f29ee65e56413b8722d51fe64f'
AND (
token = 'v0BSCuSP/T8uiCWaodvOfsGxPC4BjVHnGm6M0mAJn0Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)