UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pZSpIDhgbFX9rBUJE6oHda+bWIap1ii3GuT9edLc2JE='
WHERE
key_id = '9d541c71e204df0d6824a1b03c9e2731f4fa1ea01a651433c4e9fd88a87798fc'
AND (
token = 'pZSpIDhgbFX9rBUJE6oHda+bWIap1ii3GuT9edLc2JE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)