UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zNW1KUFndE96j/UgePvmMARCyrR68Pqm8crKUQ9JlYo='
WHERE
key_id = 'e8ed3d7def9425a6baade0a60a415d4f744b677caa2aa7750964fa7faec0a87a'
AND (
token = 'zNW1KUFndE96j/UgePvmMARCyrR68Pqm8crKUQ9JlYo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)