UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X1LnRsor9rbMg86oJ0nGQbY5v3w+s++yOSTMQPQKx7E='
WHERE
key_id = '9099deb621e90304f1f290d9ee80a25118a93ee6192d6d30b9cc317b90b64735'
AND (
token = 'X1LnRsor9rbMg86oJ0nGQbY5v3w+s++yOSTMQPQKx7E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)