UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VGS3cAZ+X6JXeZXCSSA7rJCgVXxl+Zah2DI6UtkIkHs='
WHERE
key_id = '8797a8fa6cb3c89c757da8c4119f961788706982f1291e133a454eba812f42ba'
AND (
token = 'VGS3cAZ+X6JXeZXCSSA7rJCgVXxl+Zah2DI6UtkIkHs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)