UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IdpMuP753eFKPJ10S8uupYQCL55tcviVVGbA5J7n1Jk='
WHERE
key_id = 'a6f0ce2b9917155519c10b00615b098ecf25a87dd4f7172f2da568c70a572782'
AND (
token = 'IdpMuP753eFKPJ10S8uupYQCL55tcviVVGbA5J7n1Jk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)