UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S8ErB69pAiAT/52NzkFX6iuYpGgpKXUMmK55fpllbLA='
WHERE
key_id = 'a769e7cdf30bf8351ee92a9cbf63a9e43aabc684293af1d52cdc77b2586b73fb'
AND (
token = 'S8ErB69pAiAT/52NzkFX6iuYpGgpKXUMmK55fpllbLA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)