UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WFqoTcng5EYgA4V9yRGXEK5PThvAHqVq6tq8I/riZKs='
WHERE
key_id = 'a16cd54970476d1f4e8a0e0b8dc1375012e0716c4b2e11a72b45f595d1a79fdd'
AND (
token = 'WFqoTcng5EYgA4V9yRGXEK5PThvAHqVq6tq8I/riZKs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)