UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C7tUOtAG0c1qPIMDQMrOrQZJ9v3lqHQUbrhUd9XYzgY='
WHERE
key_id = '584a018495b3553445f9505ff3675e387a95baacc8cec1dd4b6b67d751d7b38d'
AND (
token = 'C7tUOtAG0c1qPIMDQMrOrQZJ9v3lqHQUbrhUd9XYzgY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)