UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AfDggLk1fOBLeSKn6RV4tCr4eixR6ZYU9/zcaviuKio='
WHERE
key_id = 'c0785344fe5b0884945a5aa21183d3771d4c41db9275ae752c7bcc580c82ec9c'
AND (
token = 'AfDggLk1fOBLeSKn6RV4tCr4eixR6ZYU9/zcaviuKio='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)