UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MZZ3MlDYlO37a6n8ElTsTb5Q7RFUOF9M+R81f9JwWa8='
WHERE
key_id = 'd9de7b0f5e8174587a475e0a17b83690e59b228c03fc4bf1a0f3c11049cf47a7'
AND (
token = 'MZZ3MlDYlO37a6n8ElTsTb5Q7RFUOF9M+R81f9JwWa8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)