UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qBYjUo7KYWa7d53sppl88EmRJtnMQQotX1+TiFm/jmE='
WHERE
key_id = '5f4d7460f1c3a3b24e81bea71478b676303b923a34d04d8f681a3af85806ec77'
AND (
token = 'qBYjUo7KYWa7d53sppl88EmRJtnMQQotX1+TiFm/jmE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)